All Questions
12 questions
0votes
1answer
85views
Design a sequential processing of records
About 10 to 15 records are processed per day with the time interval of 5 minutes between each record. System A inserts a record in DB and sends id of that record to active mq. System B Listener ...
- 119
-1votes
3answers
322views
Is it ok to save all fields of an entity as a string if it should not be changed?
I have a complex object that has several fields can be updated until it is locked. Is it proper to save this locked entity as another entity which has no object child, only string data. complex object ...
- 109
0votes
2answers
138views
design discussion, user experience first or correctness first in our case
We are discussing the system configuration module design in our Java medical device software. The system has a voice instruction function used to guide patient during the examination. Different ...
3votes
3answers
4kviews
Java application - How to optimize database calls and space & time which is more important?
I am writing a simple Java app to run weekly. The app need call database to get data, check it and update. The flow I need is little as following: select configure,orgID where status=true from orgs; ...
- 79
1vote
0answers
92views
Creating duplicate instances of objects for timeline functionality
I am working on a Spring-MVC based project, in which I would like to add Timeline functionality. The most important object in our project is the Note, there are objects associated with it like ...
- 441
0votes
2answers
1kviews
DAO design for writing big XML file on database
I am currently working on JavaEE application (Spring, Hibernate). I have to put a big XML file (more than 1 gigabyte) on a relational database (Postgres). The application does not use batch ...
- 41
3votes
2answers
3kviews
Designing a system to archive databases with referential integrity
I have a very large Oracle database, with many many tables and millions of rows. I need to delete some of the rows end-to-end. By end-to-end, I mean, if I want to delete a row from a table then I must ...
1vote
1answer
3kviews
Is Java's ElementCollection Considered a Bad Practice?
From my understanding, an ElementCollection has no primary key, is embedded with the class, and cannot be queried. This sounds pretty hefty, but it allows me the comfort of writing an enum class which ...
- 1,458
20votes
4answers
4kviews
How to create better OO code in a relational database driven application where the database is poorly designed
I am writing a Java web application that consists mainly of a bunch of similar pages in which every page has several tables and a filter that applies to those tables. The data on these tables comes ...
- 1,723
0votes
2answers
157views
Representation of data in application versus database [closed]
I'm going to make an application that will be given data to put in a database. The data will for the most part be the same, but the way it is formatted will vary a lot (could be in anything from text ...
- 111
2votes
1answer
2kviews
Best way to lazy load blob from database in Java?
I have a database table that stores uploaded files (excel files) in a blob field. Each record contains the uploader, upload-time, the upload ID (primary key) and of-course, the blob itself. At some ...
- 355
1vote
2answers
1kviews
Database design
I'm on the way developing an application which requires a kind of dynamic database, So this is what I want, This is the for reading the details of a class, the number of variables and methods will ...
- 233
